package org.com.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.*;
import org.com.pojo.Users;

import java.util.List;
import java.util.Map;

/**
* @author 86134
* @description 针对表【users】的数据库操作Mapper
* @createDate 2025-02-26 22:01:09
* @Entity org.com.pojo.Users
*/
public interface UsersMapper extends BaseMapper<Users> {
    Users findByUsername(String username);

//
//    @Select("SELECT " +
//            "ur.apply_type, " +
//            "u.user_name AS user_name, " +
//            "u.call_name AS call_name, " +
//            "r.role_name AS role_name " +
//            "FROM user_roles ur " +
//            "INNER JOIN users u ON ur.user_id = u.user_id " +
//            "INNER JOIN roles r ON ur.role_id = r.role_id " +
//            "WHERE ur.apply_type = 0")
    List<Map<String, Object>> getApplyTypeUser();

    // 获取所有专家用户ID
    List<Integer> getExpertUserIds();
}




